DROP TABLE `jos_virtuemart_states`;
CREATE TABLE IF NOT EXISTS `jos_virtuemart_states` (
  `virtuemart_state_id` smallint(1) unsigned NOT NULL auto_increment,
  `virtuemart_vendor_id` smallint(1) unsigned NOT NULL default '1',
  `virtuemart_country_id` smallint(1) unsigned NOT NULL default '1',
  `virtuemart_worldzone_id` smallint(1) unsigned NOT NULL default '0',
  `state_name` char(64) default NULL,
  `state_3_code` char(3) default NULL,
  `state_2_code` char(2) default NULL,
  `ordering` int(2) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
  `published` tinyint(1) NOT NULL default '1',
  `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by` int(11) NOT NULL default '0',
  `modified_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified_by` int(11) NOT NULL default '0',
  `locked_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `locked_by` int(11) NOT NULL default '0',
  PRIMARY KEY  (`virtuemart_state_id`),
  UNIQUE KEY `idx_state_3_code` (`virtuemart_country_id`,`state_3_code`),
  UNIQUE KEY `idx_state_2_code` (`virtuemart_country_id`,`state_2_code`),
  KEY `i_virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `i_virtuemart_country_id` (`virtuemart_country_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='States that are assigned to a country' ;

--
-- 导出表中的数据 `jos_virtuemart_states`
--

INSERT INTO `jos_virtuemart_states` (`virtuemart_state_id`, `virtuemart_vendor_id`, `virtuemart_country_id`, `virtuemart_worldzone_id`, `state_name`, `state_3_code`, `state_2_code`, `ordering`, `shared`, `published`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES
(1, 1, 1, 0, '北京市', 'BEI', '11', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(2, 1, 1, 0, '重庆市', 'CHO', '50', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(3, 1, 1, 0, '上海市', 'SHH', '31', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(4, 1, 1, 0, '天津市', 'TIA', '12', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(5, 1, 1, 0, '安徽省', 'ANH', '34', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(6, 1, 1, 0, '福建省', 'FUJ', '35', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(7, 1, 1, 0, '甘肃省', 'GAN', '62', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(8, 1, 1, 0, '广东省', 'GUA', '44', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(9, 1, 1, 0, '广西壮族自治区', 'GUZ', '45', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(10, 1, 1, 0, '贵州省', 'GUI', '52', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(11, 1, 1, 0, '海南省', 'HAI', '46', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(12, 1, 1, 0, '河北省', 'HEB', '13', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(13, 1, 1, 0, '黑龙江省', 'HEI', '23', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(14, 1, 1, 0, '河南省', 'HEN', '41', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(15, 1, 1, 0, '湖北省', 'HUB', '42', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(16, 1, 1, 0, '湖南省', 'HUN', '43', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(17, 1, 1, 0, '江苏省', 'JIA', '32', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(18, 1, 1, 0, '江西省', 'JIX', '36', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(19, 1, 1, 0, '吉林省', 'JIL', '22', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(20, 1, 1, 0, '辽宁省', 'LIA', '21', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(21, 1, 1, 0, '内蒙古自治区', 'NML', '15', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(22, 1, 1, 0, '宁夏回族自治区', 'NIH', '64', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(23, 1, 1, 0, '青海省', 'QIN', '63', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(24, 1, 1, 0, '陕西省', 'SHA', '61', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(25, 1, 1, 0, '山东省', 'SNG', '37', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(26, 1, 1, 0, '山西省', 'SHX', '14', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(27, 1, 1, 0, '四川省', 'SIC', '51', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(28, 1, 1, 0, '新疆维吾尔自治区', 'XIU', '65', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(29, 1, 1, 0, '西藏自治区', 'XIZ', '54', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(30, 1, 1, 0, '云南省', 'YUN', '53', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0),
(31, 1, 1, 0, '浙江省', 'ZHE', '33', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0);

-- (1, 44, 'Anhui', 'ANH', 'AN'),
-- (2, 44, 'Beijing', 'BEI', 'BE'),
-- (3, 44, 'Fujian', 'FUJ', 'FJ'),
-- (5, 44, 'Gansu', 'GAN', 'GU'),
-- (6, 44, 'Guangdong', 'GUA', 'GU'),
-- (7, 44, 'Guangxi Zhuang', 'GUZ', 'GZ'),
-- (8, 44, 'Guizhou', 'GUI', 'GI'),
-- (9, 44, 'Hainan', 'HAI', 'HA'),
-- (10, 44, 'Hebei', 'HEB', 'HE'),
-- (11, 44, 'Heilongjiang', 'HEI', 'HG'),
-- (12, 44, 'Henan', 'HEN', 'HN'),
-- (13, 44, 'Hubei', 'HUB', 'HI'),
-- (14, 44, 'Hunan', 'HUN', 'HU'),
-- (15, 44, 'Jiangsu', 'JIA', 'JI'),
-- (16, 44, 'Jiangxi', 'JIX', 'JX'),
-- (17, 44, 'Jilin', 'JIL', 'JN'),
-- (18, 44, 'Liaoning', 'LIA', 'LI'),
-- (19, 44, 'Nei Mongol', 'NML', 'NM'),
-- (20, 44, 'Ningxia Hui', 'NIH', 'NH'),
-- (21, 44, 'Qinghai', 'QIN', 'QI'),
-- (22, 44, 'Shaanxi', 'SHA', 'SH'),
-- (23, 44, 'Shandong', 'SNG', 'SG'),
-- (24, 44, 'Shanghai', 'SHH', 'SI'),
-- (25, 44, 'Shanxi', 'SHX', 'SX'),
-- (26, 44, 'Sichuan', 'SIC', 'SN'),
-- (27, 44, 'Tianjin', 'TIA', 'TI'),
-- (28, 44, 'Xinjiang Uygur', 'XIU', 'XU'),
-- (29, 44, 'Xizang', 'XIZ', 'XI'),
-- (30, 44, 'Yunnan', 'YUN', 'YU'),
-- (31, 44, 'Zhejiang', 'ZHE', 'ZH')